RCG POS Event Listener - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
Module | Description |
---|---|
map-PredictSpring-orders-to-cim | PredictSpring to Orders CIM mapping |
map-PredictSpring-loyalty-customer-to-cim | PredictSpring to Loyalty Customer CIM mapping |
map-PredictSpring-orders-to-cim
PredictSpring to Orders CIM mapping
Source:
./src/main/resources/dwl/map-PredictSpring-orders-to-cim.dwl
Mapping Tables
CIM | PredictSpring | Description | |
---|---|---|---|
id | "" | "" | |
name | "SalesOrder-" ++ payload.orderId | Name of the order. | |
description | productList.imageURL | ImageURL. | |
orderNumber | orderId | orderId. | |
requestedStartDate | orderDate | orderDate. | |
orderSource | orderSource | orderSource. | |
lastDateToReturnTimeStamp | lastDateToReturnTimeStamp | last Date To Return TimeStamp. | |
salesOrderType | INITIAL | Hardcoded to INITIAL. | |
grandTotalAmount | totalAmount | Total Amount. | |
totalDeliveryFeeAmount | shippingSubTotal | Shipping SubTotal. | |
totalTaxAmount | taxSubTotal | TaxSubTotal. | |
taxExemption | taxExemption | Tax Exemption. | |
totalProductTaxAmount | orderSubTotal | orderSubTotal. | |
orderLineItems.orderProductNumber | productId | productId. | |
orderLineItems.allocationGroupName | variantGroupId | Variant GroupId. | |
orderLineItems.description | name | Name. | |
orderLineItems.totalPriceAmount | price | Price. | |
orderLineItems.orderedQuantity | quantity | quantity. | |
orderLineItems.unitTaxAmount | perUnitTaxAmount | perUnitTaxAmount. | |
orderLineItems.unitPriceAmount | productPriceAdjustments.basePrice | unitPriceAmount. | |
orderLineItems.quantityOrderedUOM | UNIT | Hardcoded to Unit. | |
orderLineItems.orderProductNumber | productList.productId | orderProductNumber. | |
orderLineItems.size | size | size. | |
orderLineItems.color | color | color. | |
orderLineItems.itemStatus | itemStatus | ||
orderLineItems.unitTaxAmount | perUnitTaxAmount | perUnitTaxAmount. | |
orderLineItems.discountAmount | discount | discount. | |
orderLineItems.totalUnitPriceAmount | productList.total | total. | |
orderLineItems.lineAdjustmentSubTotalAmount | adjustedPrice | adjustedPrice. | |
orderLineItems.product | gtin | gtin. | |
orderLineItems.fulfillmentType | fulfillmentType | fulfillmentType. | |
orderLineItems.fulfillmentSubType | fulfillmentSubType | fulfillmentSubType. | |
orderLineItems.salesAssociateId | salesAssociateId | salesAssociateId. | |
orderLineItems.salesAssociateAttribution.orderItemId | orderItemId | orderItemId. | |
orderLineItems.salesAssociateAttribution.storeId | storeId | storeId. | |
orderLineItems.salesAssociateAttribution.storeAssociateId | storeAssociateId | storeAssociateId. | |
orderLineItems.salesAssociateAttribution.contributionPercentage | contributionPercentage | contributionPercentage. | |
orderLineItems.salesAssociateAttribution.orderId | orderId | orderId. | |
orderLineItems.salesAssociateAttribution.expiryDate | expiryDate | expiryDate. | |
orderProductTax.country | countryCode | countryCode. | |
orderProductTax.name | taxType | Type of tax. | |
orderProductTax.taxRatePercent | taxRate | taxRate. | |
orderProductTax.taxClass | taxClass | taxClass. | |
orderProductTax.taxCode | taxCode | taxCode. | |
orderProductTax.salesOrderTaxAmount | taxAmount | taxAmount. | |
orderProductTax.taxAmount | perUnitTaxAmount | perUnitTaxAmount. | |
orderProductTax.name | taxName | Name of the tax. | |
orderProductTax.description | displayTaxName | displayTaxName. | |
orderProductTax.returnedTaxAmount | returnedTaxAmount | returnedTaxAmount. | |
orderAddress.id | "" | "" | |
orderAddress.personName | billingAddress.firstName + payload.billingAddress.lastName | PersonName | |
orderAddress.firstName | billingAddress.firstName | firstName | |
orderAddress.lastName | billingAddress.lastName | lastName | |
orderAddress.addressLine1 | billingAddress.addressLine1 | addressLine1 | |
orderAddress.addressLine2 | billingAddress.addressLine2 | addressLine2 | |
orderAddress.cityName | billingAddress.city | city | |
orderAddress.stateProvinceName | billingAddress.state | state | |
orderAddress.postalCodeText | billingAddress.postalCode | postalCode | |
orderAddress.countryName | billingAddress.countryCode | countryCode | |
orderAddress.personName | shippingAddress.firstName +payload.shippingAddress.lastName | PersonName | |
orderAddress.firstName | shippingAddress.firstName | firstName | |
orderAddress.lastName | shippingAddress.lastName | lastName | |
orderAddress.addressLine1 | shippingAddress.addressLine1 | addressLine1 | |
orderAddress.addressLine2 | shippingAddress.addressLine2 | addressLine2 | |
orderAddress.cityName | shippingAddress.city | city | |
orderAddress.stateProvinceName | shippingAddress.state | state | |
orderAddress.postalCodeText | shippingAddress.postalCode | postalCode | |
orderAddress.countryName | shippingAddress.countryCode | countryCode | |
orderAddress.contactPointType | [BillToAddress]or[ShipToAddress] | Type of contact | |
fullFillmentLocation.id | payload.productList.fulfillmentLocation.storeId | storeId | |
fullFillmentLocation.name | payload.productList.fulfillmentLocation.name | name | |
fullFillmentLocation.addressLine1 | payload.productList.fulfillmentLocation.addressLine1 | addressLine1 | |
fullFillmentLocation.cityName | payload.productList.fulfillmentLocation.city | city | |
fullFillmentLocation.stateProvinceName | payload.productList.fulfillmentLocation.state | state | |
fullFillmentLocation.countryName | payload.productList.fulfillmentLocation.countryCode | countryCode | |
fullFillmentLocation.geoLatitude | payload.productList.fulfillmentLocation.latitude | latitude | |
fullFillmentLocation.geoLongitude | payload.productList.fulfillmentLocation.longitude | longitude | |
fullFillmentLocation.allowTryAtStore | payload.productList.fulfillmentLocation.allowTryAtStore | allowTryAtStore | |
fullFillmentLocation.scanCodeType | payload.productList.fulfillmentLocation.productScanCodeType | productScanCodeType | |
fullFillmentLocation.timeZone | payload.productList.fulfillmentLocation.timeZoneId | timeZoneId | |
fullFillmentLocation.storeType | payload.productList.fulfillmentLocation.storeType | storeType | |
fullFillmentLocation.contactPointType | [fullFillmentLocation] | Type of contact | |
store.id | payload.productList.store.storeId | storeId | |
store.name | payload.productList.store.name | name | |
store.addressLine1 | payload.productList.store.addressLine1 | addressLine1 | |
store.cityName | payload.productList.store.city | city | |
store.stateProvinceName | payload.productList.store.state | state | |
store.countryName | payload.productList.store.countryCode | countryCode | |
store.geoLatitude | payload.productList.store.latitude | latitude | |
store.geoLongitude | payload.productList.store.longitude | longitude | |
store.allowTryAtStore | payload.productList.store.allowTryAtStore | allowTryAtStore | |
store.scanCodeType | payload.productList.store.productScanCodeType | productScanCodeType | |
store.timeZone | payload.productList.store.timeZoneId | timeZoneId | |
store.storeType | payload.productList.store.storeType | storeType | |
store.contactPointType | [fullFillmentLocation] | Type of contact | |
party.contactPoints.contactPointType | ContactPointAddress or ContactPointEmail or ContactPointPhone | Type of contactPoint. | |
party.contactpoints.id | "" | null | |
activeFromDate | now timestamp | Active from Date. | |
party.contactPoints.addressLine1 | profile.address.addressLine1 | AddressLine1. | |
party.contactPoints.cityName | profile.address.city | CityName | |
party.contactPoints.postalCodeText | profile.address.postalCode | PostalCode. | |
party.contactPoints.stateProvinceName | profile.address.state | State. | |
party.contactPoints.countryName | profile.address.countryCode | CountryCode. | |
party.contactPoints.emailAddress | profile.email | Email. | |
party.contactPoints.telephoneNumber | profile.phoneMobile | PhoneMobile. | |
orderPayment. id | null | null | |
orderPayment.transactionId | payload.paymentDetails.transactionId | transactionId | |
orderPayment.paymentId | payload.paymentDetails.paymentId | paymentId | |
orderPayment.paymentStatus | payload.paymentDetails.paymentStatus | paymentStatus | |
orderPayment.paymentMethod | payload.paymentDetails.paymentMethod | paymentMethod | |
orderPayment.paymentDevice | payload.paymentDetails.paymentDevice | paymentDevice | |
orderPayment.paymentDate | payload.paymentDetails.captureDate | captureDate | |
orderPayment.refundedAmount | payload.paymentDetails.totalRefundedAmount | totalRefundedAmount | |
orderPayment.carriedOverForExchange | payload.paymentDetails.totalAmountCarriedOverForExchange | totalAmountCarriedOverForExchange | |
orderPayment.paymentSequenceNumber | payload.paymentDetails.paymentSequenceNumber | paymentSequenceNumber | |
orderPayment.authStatus | payload.paymentDetails.authStatus | authStatus | |
orderPayment.captureStatus | payload.paymentDetails.captureStatus | captureStatus | |
orderPayment.cardPresent | payload.paymentDetails.cardPresent | cardPresent | |
orderPayment.expiryDate | payload.paymentDetails.expiryDate | expiryDate | |
productPriceAdjustment.id | prcAdj.id | id | |
productPriceAdjustment.description | prcAdj.description | description | |
productPriceAdjustment.adjustment | prcAdj.adjustment | adjustment | |
productPriceAdjustment.price | prcAdj.price | price | |
productPriceAdjustment.priceAdjustmentType | prcAdj.priceAdjustmentType | priceAdjustmentType | |
productPriceAdjustment.fulfillmentType | prcAdj.fulfillmentType | fulfillmentType | |
productPriceAdjustment.promoCode | prcAdj.promoCode | promoCode | |
productPriceAdjustment.autoAdjustment | prcAdj.auto | auto | |
productPriceAdjustment.quantity | prcAdj.quantity | quantity | |
productPriceAdjustment.discountValue | prcAdj.discountValue | discountValue | |
productPriceAdjustment.discountType | prcAdj.discountType | discountType | |
productPriceAdjustment.priceAfterItemDiscount | payload.productPriceAdjustments.priceAfterItemDiscount | priceAfterItemDiscount | |
productPriceAdjustment.totalAdjustedPrice | payload.productPriceAdjustments.totalAdjustedPrice | totalAdjustedPrice | |
productPriceAdjustment.totalTaxablePrice | payload.productPriceAdjustments.totalTaxablePrice | totalTaxablePrice | |
productPriceAdjustment.totalAddtionalCharge | payload.productPriceAdjustments.totalAddtionalCharge | totalAddtionalCharge | |
externalIds.externalIdType | NA | set to ["POS"] | |
externalIds.externalId | profile.customerId | CustomerId. | |
externalIds.statusLastChangedDate | now | "" | |
externalIds.status | NA | set to "VALID" |
map-PredictSpring-loyalty-customer-to-cim
PredictSpring to Loyalty Customer CIM mapping
Source:
./src/main/resources/dwl/map-PredictSpring-loyalty-customer-to-cim.dwl
Mapping Tables
CIM | PredictSpring | Description | |
---|---|---|---|
id | "" | null | |
partyRoleType | Party | set to Party. | |
party.personName | customers.firstName + customers.lastName | Customer Name. | |
party.firstName | loyaltyProfile.address.firstName | Customer firstName. | |
party.lastName | loyaltyProfile.address.lastName | Customer lastName. | |
party.partyType | Individual | Hardcoded to Individual. | |
party.contactPoints.contactPointType | ContactPointAddress or ContactPointEmail or ContactPointPhone | Type of contactPoint. | |
party.contactpoints.id | "" | null | |
activeFromDate | now timestamp | Active from Date. | |
party.contactPoints.addressLine1 | profile.address.addressLine1 | AddressLine1. | |
party.contactPoints.cityName | profile.address.city | CityName | |
party.contactPoints.postalCodeText | profile.address.postalCode | PostalCode. | |
party.contactPoints.stateProvinceName | profile.address.state | State. | |
party.contactPoints.countryName | profile.address.countryCode | CountryCode. | |
party.contactPoints.emailAddress | profile.email | Email. | |
party.contactPoints.telephoneNumber | profile.phoneMobile | PhoneMobile. | |
loyaltyProgramMember.accountId | profile.customerId | CustomerId. | |
loyaltyProgramMember.storeId | loyaltyProfile.address.storeId | StoreId. | |
loyaltyProgramMember.loyaltyProgramId | loyaltyProfile.accountNumber | AccountNumber. | |
loyaltyMemberTier.name | loyaltyProfile.currentTier.name | CurrentTier Name. | |
loyaltyMemberTier.display | loyaltyProfile.currentTier.display | Display Name. | |
loyaltyMemberTier.imageURL | loyaltyProfile.currentTier.imageURL | ImageURL. | |
communicationSubscriptionConsent.ownerId | loyaltyProfile.customerId | CustomerId. | |
communicationSubscriptionConsent.name | name | "agreeToTC". | |
communicationSubscriptionConsent.ownerId | loyaltyProfile.customerId | CustomerId. | |
externalIds.externalIdType | NA | set to ["POS"] | |
externalIds.externalId | profile.customerId | CustomerId. | |
externalIds.statusLastChangedDate | now | "" | |
externalIds.status | NA | set to "VALID" |